Pandas Profiling Report

Dataset statistics

Number of variables	21
Number of observations	10800
Missing cells	15325
Missing cells (%)	6.8%
Duplicate rows	206
Duplicate rows (%)	1.9%
Total size in memory	11.4 MiB
Average record size in memory	1.1 KiB

Variable types

Text	7
DateTime	2
Categorical	7
Numeric	5

Alerts

`Country` has constant value "United States"	Constant
Dataset has 206 (1.9%) duplicate rows	Duplicates
`Category` is highly overall correlated with `Sub-Category`	High correlation
`Discount` is highly overall correlated with `Profit`	High correlation
`Postal Code` is highly overall correlated with `Region` and 1 other fields	High correlation
`Profit` is highly overall correlated with `Discount` and 1 other fields	High correlation
`Region` is highly overall correlated with `Postal Code` and 1 other fields	High correlation
`Sales` is highly overall correlated with `Profit`	High correlation
`State` is highly overall correlated with `Postal Code` and 1 other fields	High correlation
`Sub-Category` is highly overall correlated with `Category`	High correlation
`Order Date` has 806 (7.5%) missing values	Missing
`Ship Date` has 806 (7.5%) missing values	Missing
`Ship Mode` has 806 (7.5%) missing values	Missing
`Customer ID` has 806 (7.5%) missing values	Missing
`Customer Name` has 806 (7.5%) missing values	Missing
`Segment` has 806 (7.5%) missing values	Missing
`Country` has 806 (7.5%) missing values	Missing
`City` has 806 (7.5%) missing values	Missing
`State` has 806 (7.5%) missing values	Missing
`Postal Code` has 817 (7.6%) missing values	Missing
`Region` has 806 (7.5%) missing values	Missing
`Product ID` has 806 (7.5%) missing values	Missing
`Category` has 806 (7.5%) missing values	Missing
`Sub-Category` has 806 (7.5%) missing values	Missing
`Product Name` has 806 (7.5%) missing values	Missing
`Sales` has 806 (7.5%) missing values	Missing
`Quantity` has 806 (7.5%) missing values	Missing
`Discount` has 806 (7.5%) missing values	Missing
`Profit` has 806 (7.5%) missing values	Missing
`Discount` has 4798 (44.4%) zeros	Zeros

Reproduction

Analysis started	2025-02-19 00:53:46.951001
Analysis finished	2025-02-19 00:54:07.699370
Duration	20.75 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

Row ID
Text

Distinct	10001
Distinct (%)	92.6%
Missing	0
Missing (%)	0.0%
Memory size	641.7 KiB

Length

Max length	17
Median length	4
Mean length	3.8275926
Min length	1

Characters and Unicode

Total characters	41338
Distinct characters	38
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10000 ?
Unique (%)	92.6%

Sample

1st row	1
2nd row	2
3rd row	3
4th row	4
5th row	5

Value	Count	Frequency (%)
yes	800	7.4%
8	1	< 0.1%
19	1	< 0.1%
18	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
9	1	< 0.1%
Other values (9995)	9995	92.5%

Most occurring characters

Value	Count	Frequency (%)
1	4000	9.7%
4	4000	9.7%
2	4000	9.7%
3	4000	9.7%
6	3999	9.7%
7	3999	9.7%
5	3999	9.7%
8	3999	9.7%
9	3984	9.6%
0	2889	7.0%
Other values (28)	2469	6.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	41338	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	4000	9.7%
4	4000	9.7%
2	4000	9.7%
3	4000	9.7%
6	3999	9.7%
7	3999	9.7%
5	3999	9.7%
8	3999	9.7%
9	3984	9.6%
0	2889	7.0%
Other values (28)	2469	6.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	41338	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	4000	9.7%
4	4000	9.7%
2	4000	9.7%
3	4000	9.7%
6	3999	9.7%
7	3999	9.7%
5	3999	9.7%
8	3999	9.7%
9	3984	9.6%
0	2889	7.0%
Other values (28)	2469	6.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	41338	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	4000	9.7%
4	4000	9.7%
2	4000	9.7%
3	4000	9.7%
6	3999	9.7%
7	3999	9.7%
5	3999	9.7%
8	3999	9.7%
9	3984	9.6%
0	2889	7.0%
Other values (28)	2469	6.0%

Order ID
Text

Distinct	5015
Distinct (%)	46.4%
Missing	0
Missing (%)	0.0%
Memory size	748.9 KiB

Length

Max length	14
Median length	14
Mean length	13.99537
Min length	4

Characters and Unicode

Total characters	151150
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2454 ?
Unique (%)	22.7%

Sample

1st row	CA-2017-152156
2nd row	CA-2017-152156
3rd row	CA-2017-138688
4th row	US-2016-108966
5th row	US-2016-108966

Value	Count	Frequency (%)
ca-2018-100111	28	0.3%
ca-2017-165330	22	0.2%
ca-2016-164882	18	0.2%
ca-2015-142769	16	0.1%
us-2018-118087	16	0.1%
ca-2018-161956	16	0.1%
ca-2018-119284	14	0.1%
ca-2017-145261	14	0.1%
ca-2018-166093	14	0.1%
ca-2015-160766	14	0.1%
Other values (5006)	10629	98.4%

Most occurring characters

Value	Count	Frequency (%)
1	27531	18.2%
-	21588	14.3%
0	16746	11.1%
2	16601	11.0%
C	8978	5.9%
A	8977	5.9%
6	8067	5.3%
8	8015	5.3%
5	7780	5.1%
7	7236	4.8%
Other values (25)	19631	13.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	151150	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	27531	18.2%
-	21588	14.3%
0	16746	11.1%
2	16601	11.0%
C	8978	5.9%
A	8977	5.9%
6	8067	5.3%
8	8015	5.3%
5	7780	5.1%
7	7236	4.8%
Other values (25)	19631	13.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	151150	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	27531	18.2%
-	21588	14.3%
0	16746	11.1%
2	16601	11.0%
C	8978	5.9%
A	8977	5.9%
6	8067	5.3%
8	8015	5.3%
5	7780	5.1%
7	7236	4.8%
Other values (25)	19631	13.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	151150	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	27531	18.2%
-	21588	14.3%
0	16746	11.1%
2	16601	11.0%
C	8978	5.9%
A	8977	5.9%
6	8067	5.3%
8	8015	5.3%
5	7780	5.1%
7	7236	4.8%
Other values (25)	19631	13.0%

Order Date
Date

Missing

Distinct	1236
Distinct (%)	12.4%
Missing	806
Missing (%)	7.5%
Memory size	84.5 KiB

Minimum	2015-01-03 00:00:00
Maximum	2018-12-30 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Ship Date
Date

Missing

Distinct	1334
Distinct (%)	13.3%
Missing	806
Missing (%)	7.5%
Memory size	84.5 KiB

Minimum	2015-01-07 00:00:00
Maximum	2019-01-05 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Ship Mode
Categorical

Missing

Distinct	4
Distinct (%)	< 0.1%
Missing	806
Missing (%)	7.5%
Memory size	713.1 KiB

Standard Class	5968
Second Class	1945
First Class	1538
Same Day	543

Length

Max length	14
Median length	14
Mean length	12.823094
Min length	8

Characters and Unicode

Total characters	128154
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Second Class
2nd row	Second Class
3rd row	Second Class
4th row	Standard Class
5th row	Standard Class

Common Values

Value	Count	Frequency (%)
Standard Class	5968	55.3%
Second Class	1945	18.0%
First Class	1538	14.2%
Same Day	543	5.0%
(Missing)	806	7.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
class	9451	47.3%
standard	5968	29.9%
second	1945	9.7%
first	1538	7.7%
same	543	2.7%
day	543	2.7%

Most occurring characters

Value	Count	Frequency (%)
a	22473	17.5%
s	20440	15.9%
d	13881	10.8%
	9994	7.8%
l	9451	7.4%
C	9451	7.4%
S	8456	6.6%
n	7913	6.2%
r	7506	5.9%
t	7506	5.9%
Other values (8)	11083	8.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	128154	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	22473	17.5%
s	20440	15.9%
d	13881	10.8%
	9994	7.8%
l	9451	7.4%
C	9451	7.4%
S	8456	6.6%
n	7913	6.2%
r	7506	5.9%
t	7506	5.9%
Other values (8)	11083	8.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	128154	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	22473	17.5%
s	20440	15.9%
d	13881	10.8%
	9994	7.8%
l	9451	7.4%
C	9451	7.4%
S	8456	6.6%
n	7913	6.2%
r	7506	5.9%
t	7506	5.9%
Other values (8)	11083	8.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	128154	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	22473	17.5%
s	20440	15.9%
d	13881	10.8%
	9994	7.8%
l	9451	7.4%
C	9451	7.4%
S	8456	6.6%
n	7913	6.2%
r	7506	5.9%
t	7506	5.9%
Other values (8)	11083	8.6%

Customer ID
Text

Missing

Distinct	793
Distinct (%)	7.9%
Missing	806
Missing (%)	7.5%
Memory size	659.7 KiB

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	79952
Distinct characters	40
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	0.1%

Sample

1st row	CG-12520
2nd row	CG-12520
3rd row	DV-13045
4th row	SO-20335
5th row	SO-20335

Value	Count	Frequency (%)
wb-21850	37	0.4%
jl-15835	34	0.3%
ma-17560	34	0.3%
pp-18955	34	0.3%
jd-15895	32	0.3%
eh-13765	32	0.3%
ck-12205	32	0.3%
sv-20365	32	0.3%
ep-13915	31	0.3%
zc-21910	31	0.3%
Other values (783)	9665	96.7%

Most occurring characters

Value	Count	Frequency (%)
1	11915	14.9%
-	9994	12.5%
0	8532	10.7%
5	7865	9.8%
2	4682	5.9%
7	2931	3.7%
6	2909	3.6%
9	2904	3.6%
8	2818	3.5%
3	2779	3.5%
Other values (30)	22623	28.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	79952	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	11915	14.9%
-	9994	12.5%
0	8532	10.7%
5	7865	9.8%
2	4682	5.9%
7	2931	3.7%
6	2909	3.6%
9	2904	3.6%
8	2818	3.5%
3	2779	3.5%
Other values (30)	22623	28.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	79952	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	11915	14.9%
-	9994	12.5%
0	8532	10.7%
5	7865	9.8%
2	4682	5.9%
7	2931	3.7%
6	2909	3.6%
9	2904	3.6%
8	2818	3.5%
3	2779	3.5%
Other values (30)	22623	28.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	79952	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	11915	14.9%
-	9994	12.5%
0	8532	10.7%
5	7865	9.8%
2	4682	5.9%
7	2931	3.7%
6	2909	3.6%
9	2904	3.6%
8	2818	3.5%
3	2779	3.5%
Other values (30)	22623	28.3%

Customer Name
Text

Missing

Distinct	793
Distinct (%)	7.9%
Missing	806
Missing (%)	7.5%
Memory size	711.6 KiB

Length

Max length	22
Median length	18
Mean length	12.960676
Min length	7

Characters and Unicode

Total characters	129529
Distinct characters	57
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	0.1%

Sample

1st row	Claire Gute
2nd row	Claire Gute
3rd row	Darrin Van Huff
4th row	Sean O'Donnell
5th row	Sean O'Donnell

Value	Count	Frequency (%)
michael	120	0.6%
frank	112	0.6%
john	107	0.5%
patrick	96	0.5%
stewart	93	0.5%
brian	93	0.5%
paul	92	0.5%
rick	91	0.5%
ken	91	0.5%
matt	86	0.4%
Other values (901)	19072	95.1%

Most occurring characters

Value	Count	Frequency (%)
a	12011	9.3%
e	11836	9.1%
n	10241	7.9%
	10059	7.8%
r	9530	7.4%
i	7919	6.1%
l	6494	5.0%
o	5850	4.5%
t	5435	4.2%
s	4546	3.5%
Other values (47)	45608	35.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	129529	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	12011	9.3%
e	11836	9.1%
n	10241	7.9%
	10059	7.8%
r	9530	7.4%
i	7919	6.1%
l	6494	5.0%
o	5850	4.5%
t	5435	4.2%
s	4546	3.5%
Other values (47)	45608	35.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	129529	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	12011	9.3%
e	11836	9.1%
n	10241	7.9%
	10059	7.8%
r	9530	7.4%
i	7919	6.1%
l	6494	5.0%
o	5850	4.5%
t	5435	4.2%
s	4546	3.5%
Other values (47)	45608	35.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	129529	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	12011	9.3%
e	11836	9.1%
n	10241	7.9%
	10059	7.8%
r	9530	7.4%
i	7919	6.1%
l	6494	5.0%
o	5850	4.5%
t	5435	4.2%
s	4546	3.5%
Other values (47)	45608	35.2%

Segment
Categorical

Missing

Distinct	3
Distinct (%)	< 0.1%
Missing	806
Missing (%)	7.5%
Memory size	674.2 KiB

Consumer	5191
Corporate	3020
Home Office	1783

Length

Max length	11
Median length	8
Mean length	8.8374024
Min length	8

Characters and Unicode

Total characters	88321
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Consumer
2nd row	Consumer
3rd row	Corporate
4th row	Consumer
5th row	Consumer

Common Values

Value	Count	Frequency (%)
Consumer	5191	48.1%
Corporate	3020	28.0%
Home Office	1783	16.5%
(Missing)	806	7.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
consumer	5191	44.1%
corporate	3020	25.6%
home	1783	15.1%
office	1783	15.1%

Most occurring characters

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
n	5191	5.9%
s	5191	5.9%
u	5191	5.9%
f	3566	4.0%
t	3020	3.4%
Other values (7)	14955	16.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	88321	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
n	5191	5.9%
s	5191	5.9%
u	5191	5.9%
f	3566	4.0%
t	3020	3.4%
Other values (7)	14955	16.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	88321	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
n	5191	5.9%
s	5191	5.9%
u	5191	5.9%
f	3566	4.0%
t	3020	3.4%
Other values (7)	14955	16.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	88321	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
n	5191	5.9%
s	5191	5.9%
u	5191	5.9%
f	3566	4.0%
t	3020	3.4%
Other values (7)	14955	16.9%

Country
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	806
Missing (%)	7.5%
Memory size	714.8 KiB

United States	9994

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	129922
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	United States
2nd row	United States
3rd row	United States
4th row	United States
5th row	United States

Common Values

Value	Count	Frequency (%)
United States	9994	92.5%
(Missing)	806	7.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
united	9994	50.0%
states	9994	50.0%

Most occurring characters

Value	Count	Frequency (%)
t	29982	23.1%
e	19988	15.4%
U	9994	7.7%
n	9994	7.7%
i	9994	7.7%
d	9994	7.7%
	9994	7.7%
S	9994	7.7%
a	9994	7.7%
s	9994	7.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	129922	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	29982	23.1%
e	19988	15.4%
U	9994	7.7%
n	9994	7.7%
i	9994	7.7%
d	9994	7.7%
	9994	7.7%
S	9994	7.7%
a	9994	7.7%
s	9994	7.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	129922	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	29982	23.1%
e	19988	15.4%
U	9994	7.7%
n	9994	7.7%
i	9994	7.7%
d	9994	7.7%
	9994	7.7%
S	9994	7.7%
a	9994	7.7%
s	9994	7.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	129922	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	29982	23.1%
e	19988	15.4%
U	9994	7.7%
n	9994	7.7%
i	9994	7.7%
d	9994	7.7%
	9994	7.7%
S	9994	7.7%
a	9994	7.7%
s	9994	7.7%

City
Text

Missing

Distinct	531
Distinct (%)	5.3%
Missing	806
Missing (%)	7.5%
Memory size	672.7 KiB

Length

Max length	17
Median length	14
Mean length	9.3306984
Min length	4

Characters and Unicode

Total characters	93251
Distinct characters	51
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	70 ?
Unique (%)	0.7%

Sample

1st row	Henderson
2nd row	Henderson
3rd row	Los Angeles
4th row	Fort Lauderdale
5th row	Fort Lauderdale

Value	Count	Frequency (%)
city	994	7.0%
new	937	6.6%
york	920	6.5%
san	805	5.7%
los	747	5.2%
angeles	747	5.2%
philadelphia	537	3.8%
francisco	510	3.6%
seattle	428	3.0%
houston	377	2.6%
Other values (555)	7234	50.8%

Most occurring characters

Value	Count	Frequency (%)
e	8719	9.4%
a	7591	8.1%
o	7499	8.0%
i	6229	6.7%
n	6199	6.6%
l	5986	6.4%
s	4699	5.0%
r	4468	4.8%
t	4438	4.8%
	4242	4.5%
Other values (41)	33181	35.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	93251	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	8719	9.4%
a	7591	8.1%
o	7499	8.0%
i	6229	6.7%
n	6199	6.6%
l	5986	6.4%
s	4699	5.0%
r	4468	4.8%
t	4438	4.8%
	4242	4.5%
Other values (41)	33181	35.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	93251	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	8719	9.4%
a	7591	8.1%
o	7499	8.0%
i	6229	6.7%
n	6199	6.6%
l	5986	6.4%
s	4699	5.0%
r	4468	4.8%
t	4438	4.8%
	4242	4.5%
Other values (41)	33181	35.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	93251	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	8719	9.4%
a	7591	8.1%
o	7499	8.0%
i	6229	6.7%
n	6199	6.6%
l	5986	6.4%
s	4699	5.0%
r	4468	4.8%
t	4438	4.8%
	4242	4.5%
Other values (41)	33181	35.6%

State
Categorical

High correlation Missing

Distinct	49
Distinct (%)	0.5%
Missing	806
Missing (%)	7.5%
Memory size	670.7 KiB

California	2001
New York	1128
Texas	985
Pennsylvania	587
Washington	506
Other values (44)	4787

Length

Max length	20
Median length	14
Mean length	8.4871923
Min length	4

Characters and Unicode

Total characters	84821
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Kentucky
2nd row	Kentucky
3rd row	California
4th row	Florida
5th row	Florida

Common Values

Value	Count	Frequency (%)
California	2001	18.5%
New York	1128	10.4%
Texas	985	9.1%
Pennsylvania	587	5.4%
Washington	506	4.7%
Illinois	492	4.6%
Ohio	469	4.3%
Florida	383	3.5%
Michigan	255	2.4%
North Carolina	249	2.3%
Other values (39)	2939	27.2%
(Missing)	806	7.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
california	2001	17.1%
new	1322	11.3%
york	1128	9.6%
texas	985	8.4%
pennsylvania	587	5.0%
washington	506	4.3%
illinois	492	4.2%
ohio	469	4.0%
florida	383	3.3%
carolina	291	2.5%
Other values (43)	3542	30.3%

Most occurring characters

Value	Count	Frequency (%)
a	10758	12.7%
i	9895	11.7%
n	8090	9.5%
o	7323	8.6%
r	5544	6.5%
e	5051	6.0%
l	4822	5.7%
s	4604	5.4%
C	2566	3.0%
f	2011	2.4%
Other values (36)	24157	28.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	84821	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	10758	12.7%
i	9895	11.7%
n	8090	9.5%
o	7323	8.6%
r	5544	6.5%
e	5051	6.0%
l	4822	5.7%
s	4604	5.4%
C	2566	3.0%
f	2011	2.4%
Other values (36)	24157	28.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	84821	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	10758	12.7%
i	9895	11.7%
n	8090	9.5%
o	7323	8.6%
r	5544	6.5%
e	5051	6.0%
l	4822	5.7%
s	4604	5.4%
C	2566	3.0%
f	2011	2.4%
Other values (36)	24157	28.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	84821	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	10758	12.7%
i	9895	11.7%
n	8090	9.5%
o	7323	8.6%
r	5544	6.5%
e	5051	6.0%
l	4822	5.7%
s	4604	5.4%
C	2566	3.0%
f	2011	2.4%
Other values (36)	24157	28.5%

Postal Code
Real number (ℝ)

High correlation Missing

Distinct	630
Distinct (%)	6.3%
Missing	817
Missing (%)	7.6%
Infinite	0
Infinite (%)	0.0%
Mean	55245.233

Minimum	1040
Maximum	99301
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	84.5 KiB

Quantile statistics

Minimum	1040
5-th percentile	10009
Q1	23223
median	57103
Q3	90008
95-th percentile	98006
Maximum	99301
Range	98261
Interquartile range (IQR)	66785

Descriptive statistics

Standard deviation	32038.716
Coefficient of variation (CV)	0.5799363
Kurtosis	-1.4922003
Mean	55245.233
Median Absolute Deviation (MAD)	32929
Skewness	-0.12997082
Sum	5.5151316 × 10⁸
Variance	1.0264793 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10035	263	2.4%
10024	230	2.1%
10009	229	2.1%
94122	203	1.9%
10011	193	1.8%
94110	166	1.5%
98105	165	1.5%
19134	160	1.5%
90049	151	1.4%
98103	151	1.4%
Other values (620)	8072	74.7%
(Missing)	817	7.6%

Value	Count	Frequency (%)
1040	1	< 0.1%
1453	6	0.1%
1752	2	< 0.1%
1810	4	< 0.1%
1841	33	0.3%
1852	16	0.1%
1915	3	< 0.1%
2038	17	0.2%
2138	6	0.1%
2148	3	< 0.1%

Value	Count	Frequency (%)
99301	6	0.1%
99207	7	0.1%
98661	5	< 0.1%
98632	3	< 0.1%
98502	5	< 0.1%
98270	2	< 0.1%
98226	3	< 0.1%
98208	1	< 0.1%
98198	7	0.1%
98115	112	1.0%

Region
Categorical

High correlation Missing

Distinct	4
Distinct (%)	< 0.1%
Missing	806
Missing (%)	7.5%
Memory size	635.3 KiB

West	3203
East	2848
Central	2323
South	1620

Length

Max length	7
Median length	4
Mean length	4.8594156
Min length	4

Characters and Unicode

Total characters	48565
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	South
2nd row	South
3rd row	West
4th row	South
5th row	South

Common Values

Value	Count	Frequency (%)
West	3203	29.7%
East	2848	26.4%
Central	2323	21.5%
South	1620	15.0%
(Missing)	806	7.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
west	3203	32.0%
east	2848	28.5%
central	2323	23.2%
south	1620	16.2%

Most occurring characters

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	48565	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	48565	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	48565	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Product ID
Text

Missing

Distinct	1862
Distinct (%)	18.6%
Missing	806
Missing (%)	7.5%
Memory size	728.0 KiB

Length

Max length	15
Median length	15
Mean length	15
Min length	15

Characters and Unicode

Total characters	149910
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	91 ?
Unique (%)	0.9%

Sample

1st row	FUR-BO-10001798
2nd row	FUR-CH-10000454
3rd row	OFF-LA-10000240
4th row	FUR-TA-10000577
5th row	OFF-ST-10000760

Value	Count	Frequency (%)
off-pa-10001970	19	0.2%
tec-ac-10003832	18	0.2%
fur-fu-10004270	16	0.2%
tec-ac-10002049	15	0.2%
fur-ch-10001146	15	0.2%
fur-ch-10002647	15	0.2%
tec-ac-10003628	15	0.2%
off-bi-10001524	14	0.1%
fur-ch-10003774	14	0.1%
fur-fu-10001473	14	0.1%
Other values (1852)	9839	98.4%

Most occurring characters

Value	Count	Frequency (%)
0	35052	23.4%
-	19988	13.3%
F	15347	10.2%
1	14995	10.0%
O	6322	4.2%
2	4862	3.2%
4	4831	3.2%
3	4805	3.2%
A	4422	2.9%
5	3401	2.3%
Other values (17)	35885	23.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	149910	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	35052	23.4%
-	19988	13.3%
F	15347	10.2%
1	14995	10.0%
O	6322	4.2%
2	4862	3.2%
4	4831	3.2%
3	4805	3.2%
A	4422	2.9%
5	3401	2.3%
Other values (17)	35885	23.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	149910	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	35052	23.4%
-	19988	13.3%
F	15347	10.2%
1	14995	10.0%
O	6322	4.2%
2	4862	3.2%
4	4831	3.2%
3	4805	3.2%
A	4422	2.9%
5	3401	2.3%
Other values (17)	35885	23.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	149910	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	35052	23.4%
-	19988	13.3%
F	15347	10.2%
1	14995	10.0%
O	6322	4.2%
2	4862	3.2%
4	4831	3.2%
3	4805	3.2%
A	4422	2.9%
5	3401	2.3%
Other values (17)	35885	23.9%

Category
Categorical

High correlation Missing

Distinct	3
Distinct (%)	< 0.1%
Missing	806
Missing (%)	7.5%
Memory size	712.9 KiB

Office Supplies	6026
Furniture	2121
Technology	1847

Length

Max length	15
Median length	15
Mean length	12.802582
Min length	9

Characters and Unicode

Total characters	127949
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Furniture
2nd row	Furniture
3rd row	Office Supplies
4th row	Furniture
5th row	Office Supplies

Common Values

Value	Count	Frequency (%)
Office Supplies	6026	55.8%
Furniture	2121	19.6%
Technology	1847	17.1%
(Missing)	806	7.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
office	6026	37.6%
supplies	6026	37.6%
furniture	2121	13.2%
technology	1847	11.5%

Most occurring characters

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
s	6026	4.7%
S	6026	4.7%
Other values (10)	29560	23.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	127949	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
s	6026	4.7%
S	6026	4.7%
Other values (10)	29560	23.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	127949	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
s	6026	4.7%
S	6026	4.7%
Other values (10)	29560	23.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	127949	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
s	6026	4.7%
S	6026	4.7%
Other values (10)	29560	23.1%

Sub-Category
Categorical

High correlation Missing

Distinct	17
Distinct (%)	0.2%
Missing	806
Missing (%)	7.5%
Memory size	658.1 KiB

Binders	1523
Paper	1370
Furnishings	957
Phones	889
Storage	846
Other values (12)	4409

Length

Max length	11
Median length	9
Mean length	7.191715
Min length	3

Characters and Unicode

Total characters	71874
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Bookcases
2nd row	Chairs
3rd row	Labels
4th row	Tables
5th row	Storage

Common Values

Value	Count	Frequency (%)
Binders	1523	14.1%
Paper	1370	12.7%
Furnishings	957	8.9%
Phones	889	8.2%
Storage	846	7.8%
Art	796	7.4%
Accessories	775	7.2%
Chairs	617	5.7%
Appliances	466	4.3%
Labels	364	3.4%
Other values (7)	1391	12.9%
(Missing)	806	7.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
binders	1523	15.2%
paper	1370	13.7%
furnishings	957	9.6%
phones	889	8.9%
storage	846	8.5%
art	796	8.0%
accessories	775	7.8%
chairs	617	6.2%
appliances	466	4.7%
labels	364	3.6%
Other values (7)	1391	13.9%

Most occurring characters

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	71874	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	71874	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	71874	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Product Name
Text

Missing

Distinct	1850
Distinct (%)	18.5%
Missing	806
Missing (%)	7.5%
Memory size	964.7 KiB

Length

Max length	127
Median length	78
Mean length	36.914449
Min length	5

Characters and Unicode

Total characters	368923
Distinct characters	85
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	91 ?
Unique (%)	0.9%

Sample

1st row	Bush Somerset Collection Bookcase
2nd row	Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back
3rd row	Self-Adhesive Address Labels for Typewriters by Universal
4th row	Bretford CR4500 Series Slim Rectangular Table
5th row	Eldon Fold 'N Roll Cart System

Value	Count	Frequency (%)
xerox	865	1.5%
x	701	1.3%
	599	1.1%
with	599	1.1%
avery	557	1.0%
for	539	1.0%
binders	524	0.9%
chair	479	0.9%
black	426	0.8%
phone	374	0.7%
Other values (2798)	50371	89.9%

Most occurring characters

Value	Count	Frequency (%)
	45654	12.4%
e	33538	9.1%
r	20791	5.6%
o	19902	5.4%
a	19064	5.2%
i	18648	5.1%
l	16365	4.4%
n	15622	4.2%
s	14683	4.0%
t	14550	3.9%
Other values (75)	150106	40.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	368923	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	45654	12.4%
e	33538	9.1%
r	20791	5.6%
o	19902	5.4%
a	19064	5.2%
i	18648	5.1%
l	16365	4.4%
n	15622	4.2%
s	14683	4.0%
t	14550	3.9%
Other values (75)	150106	40.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	368923	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	45654	12.4%
e	33538	9.1%
r	20791	5.6%
o	19902	5.4%
a	19064	5.2%
i	18648	5.1%
l	16365	4.4%
n	15622	4.2%
s	14683	4.0%
t	14550	3.9%
Other values (75)	150106	40.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	368923	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	45654	12.4%
e	33538	9.1%
r	20791	5.6%
o	19902	5.4%
a	19064	5.2%
i	18648	5.1%
l	16365	4.4%
n	15622	4.2%
s	14683	4.0%
t	14550	3.9%
Other values (75)	150106	40.7%

Sales
Real number (ℝ)

High correlation Missing

Distinct	5825
Distinct (%)	58.3%
Missing	806
Missing (%)	7.5%
Infinite	0
Infinite (%)	0.0%
Mean	229.858

Minimum	0.444
Maximum	22638.48
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	84.5 KiB

Quantile statistics

Minimum	0.444
5-th percentile	4.98
Q1	17.28
median	54.49
Q3	209.94
95-th percentile	956.98425
Maximum	22638.48
Range	22638.036
Interquartile range (IQR)	192.66

Descriptive statistics

Standard deviation	623.2451
Coefficient of variation (CV)	2.7114353
Kurtosis	305.31175
Mean	229.858
Median Absolute Deviation (MAD)	45.406
Skewness	12.972752
Sum	2297200.9
Variance	388434.46
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.96	56	0.5%
19.44	39	0.4%
15.552	39	0.4%
25.92	36	0.3%
10.368	36	0.3%
32.4	28	0.3%
6.48	21	0.2%
17.94	21	0.2%
20.736	19	0.2%
14.94	17	0.2%
Other values (5815)	9682	89.6%
(Missing)	806	7.5%

Value	Count	Frequency (%)
0.444	1	< 0.1%
0.556	1	< 0.1%
0.836	1	< 0.1%
0.852	1	< 0.1%
0.876	1	< 0.1%
0.898	1	< 0.1%
0.984	1	< 0.1%
0.99	1	< 0.1%
1.044	1	< 0.1%
1.08	3	< 0.1%

Value	Count	Frequency (%)
22638.48	1	< 0.1%
17499.95	1	< 0.1%
13999.96	1	< 0.1%
11199.968	1	< 0.1%
10499.97	1	< 0.1%
9892.74	1	< 0.1%
9449.95	1	< 0.1%
9099.93	1	< 0.1%
8749.95	1	< 0.1%
8399.976	1	< 0.1%

Quantity
Real number (ℝ)

Missing

Distinct	14
Distinct (%)	0.1%
Missing	806
Missing (%)	7.5%
Infinite	0
Infinite (%)	0.0%
Mean	3.7895737

Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	84.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	8
Maximum	14
Range	13
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.2251097
Coefficient of variation (CV)	0.58716622
Kurtosis	1.9918894
Mean	3.7895737
Median Absolute Deviation (MAD)	1
Skewness	1.2785448
Sum	37873
Variance	4.9511131
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
3	2409	22.3%
2	2402	22.2%
5	1230	11.4%
4	1191	11.0%
1	899	8.3%
7	606	5.6%
6	572	5.3%
9	258	2.4%
8	257	2.4%
10	57	0.5%
Other values (4)	113	1.0%
(Missing)	806	7.5%

Value	Count	Frequency (%)
1	899	8.3%
2	2402	22.2%
3	2409	22.3%
4	1191	11.0%
5	1230	11.4%
6	572	5.3%
7	606	5.6%
8	257	2.4%
9	258	2.4%
10	57	0.5%

Value	Count	Frequency (%)
14	29	0.3%
13	27	0.2%
12	23	0.2%
11	34	0.3%
10	57	0.5%
9	258	2.4%
8	257	2.4%
7	606	5.6%
6	572	5.3%
5	1230	11.4%

Discount
Real number (ℝ)

High correlation Missing Zeros

Distinct	12
Distinct (%)	0.1%
Missing	806
Missing (%)	7.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.15620272

Minimum	0
Maximum	0.8
Zeros	4798
Zeros (%)	44.4%
Negative	0
Negative (%)	0.0%
Memory size	84.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.2
Q3	0.2
95-th percentile	0.7
Maximum	0.8
Range	0.8
Interquartile range (IQR)	0.2

Descriptive statistics

Standard deviation	0.20645197
Coefficient of variation (CV)	1.3216925
Kurtosis	2.4095461
Mean	0.15620272
Median Absolute Deviation (MAD)	0.2
Skewness	1.6842947
Sum	1561.09
Variance	0.042622415
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	4798	44.4%
0.2	3657	33.9%
0.7	418	3.9%
0.8	300	2.8%
0.3	227	2.1%
0.4	206	1.9%
0.6	138	1.3%
0.1	94	0.9%
0.5	66	0.6%
0.15	52	0.5%
Other values (2)	38	0.4%
(Missing)	806	7.5%

Value	Count	Frequency (%)
0	4798	44.4%
0.1	94	0.9%
0.15	52	0.5%
0.2	3657	33.9%
0.3	227	2.1%
0.32	27	0.2%
0.4	206	1.9%
0.45	11	0.1%
0.5	66	0.6%
0.6	138	1.3%

Value	Count	Frequency (%)
0.8	300	2.8%
0.7	418	3.9%
0.6	138	1.3%
0.5	66	0.6%
0.45	11	0.1%
0.4	206	1.9%
0.32	27	0.2%
0.3	227	2.1%
0.2	3657	33.9%
0.15	52	0.5%

Profit
Real number (ℝ)

High correlation Missing

Distinct	7287
Distinct (%)	72.9%
Missing	806
Missing (%)	7.5%
Infinite	0
Infinite (%)	0.0%
Mean	28.656896

Minimum	-6599.978
Maximum	8399.976
Zeros	65
Zeros (%)	0.6%
Negative	1871
Negative (%)	17.3%
Memory size	84.5 KiB

Quantile statistics

Minimum	-6599.978
5-th percentile	-53.03092
Q1	1.72875
median	8.6665
Q3	29.364
95-th percentile	168.4704
Maximum	8399.976
Range	14999.954
Interquartile range (IQR)	27.63525

Descriptive statistics

Standard deviation	234.26011
Coefficient of variation (CV)	8.1746504
Kurtosis	397.18851
Mean	28.656896
Median Absolute Deviation (MAD)	10.77855
Skewness	7.5614316
Sum	286397.02
Variance	54877.798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	65	0.6%
6.2208	43	0.4%
9.3312	38	0.4%
3.6288	32	0.3%
5.4432	32	0.3%
15.552	26	0.2%
12.4416	21	0.2%
7.2576	19	0.2%
3.1104	18	0.2%
9.072	11	0.1%
Other values (7277)	9689	89.7%
(Missing)	806	7.5%

Value	Count	Frequency (%)
-6599.978	1	< 0.1%
-3839.9904	1	< 0.1%
-3701.8928	1	< 0.1%
-3399.98	1	< 0.1%
-2929.4845	1	< 0.1%
-2639.9912	1	< 0.1%
-2287.782	1	< 0.1%
-1862.3124	1	< 0.1%
-1850.9464	1	< 0.1%
-1811.0784	1	< 0.1%

Value	Count	Frequency (%)
8399.976	1	< 0.1%
6719.9808	1	< 0.1%
5039.9856	1	< 0.1%
4946.37	1	< 0.1%
4630.4755	1	< 0.1%
3919.9888	1	< 0.1%
3177.475	1	< 0.1%
2799.984	1	< 0.1%
2591.9568	1	< 0.1%
2504.2216	1	< 0.1%

	Category	Discount	Postal Code	Profit	Quantity	Region	Sales	Segment	Ship Mode	State	Sub-Category
Category	1.000	0.377	0.000	0.056	0.000	0.000	0.072	0.000	0.000	0.019	0.999
Discount	0.377	1.000	0.051	-0.543	-0.001	0.294	-0.057	0.005	0.027	0.354	0.353
Postal Code	0.000	0.051	1.000	-0.004	0.014	0.921	-0.001	0.035	0.038	0.968	0.000
Profit	0.056	-0.543	-0.004	1.000	0.234	0.021	0.518	0.000	0.005	0.017	0.130
Quantity	0.000	-0.001	0.014	0.234	1.000	0.000	0.327	0.012	0.000	0.004	0.000
Region	0.000	0.294	0.921	0.021	0.000	1.000	0.000	0.000	0.022	0.998	0.000
Sales	0.072	-0.057	-0.001	0.518	0.327	0.000	1.000	0.002	0.000	0.000	0.142
Segment	0.000	0.005	0.035	0.000	0.012	0.000	0.002	1.000	0.033	0.090	0.000
Ship Mode	0.000	0.027	0.038	0.005	0.000	0.022	0.000	0.033	1.000	0.096	0.007
State	0.019	0.354	0.968	0.017	0.004	0.998	0.000	0.090	0.096	1.000	0.000
Sub-Category	0.999	0.353	0.000	0.130	0.000	0.000	0.142	0.000	0.007	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	Row ID	Order ID	Order Date	Ship Date	Ship Mode	Customer ID	Customer Name	Segment	Country	City	State	Postal Code	Region	Product ID	Category	Sub-Category	Product Name	Sales	Quantity	Discount	Profit
0	1	CA-2017-152156	11/8/2017	11/11/2017	Second Class	CG-12520	Claire Gute	Consumer	United States	Henderson	Kentucky	42420.0	South	FUR-BO-10001798	Furniture	Bookcases	Bush Somerset Collection Bookcase	261.9600	2.0	0.00	41.9136
1	2	CA-2017-152156	11/8/2017	11/11/2017	Second Class	CG-12520	Claire Gute	Consumer	United States	Henderson	Kentucky	42420.0	South	FUR-CH-10000454	Furniture	Chairs	Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back	731.9400	3.0	0.00	219.5820
2	3	CA-2017-138688	6/12/2017	6/16/2017	Second Class	DV-13045	Darrin Van Huff	Corporate	United States	Los Angeles	California	90036.0	West	OFF-LA-10000240	Office Supplies	Labels	Self-Adhesive Address Labels for Typewriters by Universal	14.6200	2.0	0.00	6.8714
3	4	US-2016-108966	10/11/2016	10/18/2016	Standard Class	SO-20335	Sean O'Donnell	Consumer	United States	Fort Lauderdale	Florida	33311.0	South	FUR-TA-10000577	Furniture	Tables	Bretford CR4500 Series Slim Rectangular Table	957.5775	5.0	0.45	-383.0310
4	5	US-2016-108966	10/11/2016	10/18/2016	Standard Class	SO-20335	Sean O'Donnell	Consumer	United States	Fort Lauderdale	Florida	33311.0	South	OFF-ST-10000760	Office Supplies	Storage	Eldon Fold 'N Roll Cart System	22.3680	2.0	0.20	2.5164
5	6	CA-2015-115812	6/9/2015	6/14/2015	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032.0	West	FUR-FU-10001487	Furniture	Furnishings	Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood	48.8600	7.0	0.00	14.1694
6	7	CA-2015-115812	6/9/2015	6/14/2015	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032.0	West	OFF-AR-10002833	Office Supplies	Art	Newell 322	7.2800	4.0	0.00	1.9656
7	8	CA-2015-115812	6/9/2015	6/14/2015	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032.0	West	TEC-PH-10002275	Technology	Phones	Mitel 5320 IP Phone VoIP phone	907.1520	6.0	0.20	90.7152
8	9	CA-2015-115812	6/9/2015	6/14/2015	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032.0	West	OFF-BI-10003910	Office Supplies	Binders	DXL Angle-View Binders with Locking Rings by Samsill	18.5040	3.0	0.20	5.7825
9	10	CA-2015-115812	6/9/2015	6/14/2015	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032.0	West	OFF-AP-10002892	Office Supplies	Appliances	Belkin F5C206VTEL 6 Outlet Surge	114.9000	5.0	0.00	34.4700

	Row ID	Order ID	Order Date	Ship Date	Ship Mode	Customer ID	Customer Name	Segment	Country	City	State	Postal Code	Region	Product ID	Category	Sub-Category	Product Name	Sales	Quantity	Discount	Profit
10790	Yes	US-2018-147886	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
10791	Yes	US-2018-147886	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
10792	Yes	US-2018-147886	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
10793	Yes	US-2018-147886	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
10794	Yes	US-2018-147886	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
10795	Yes	US-2018-147886	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
10796	Yes	US-2018-147998	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
10797	Yes	US-2018-151127	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
10798	Yes	US-2018-155999	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
10799	Yes	US-2018-155999	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Most frequently occurring

	Row ID	Order ID	Order Date	Ship Date	Ship Mode	Customer ID	Customer Name	Segment	Country	City	State	Postal Code	Region	Product ID	Category	Sub-Category	Product Name	Sales	Quantity	Discount	Profit	# duplicates
108	Yes	CA-2018-100111	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14
107	Yes	CA-2017-165330	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11
70	Yes	CA-2016-164882	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9
19	Yes	CA-2015-142769	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8
160	Yes	CA-2018-161956	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8
202	Yes	US-2018-118087	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8
6	Yes	CA-2015-110786	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7
28	Yes	CA-2015-160766	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7
79	Yes	CA-2017-111682	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7
96	Yes	CA-2017-145261	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block